The Global Options page consists of settings for Global Options that can be edited by the Reconciliations Global Admin or OneStream Administrator.
Global Options
Security
Solution Administration Group:: Anyone assigned to this OneStream User Group is considered a super user who can configure any aspect of Account Reconciliations and also prepare, approve, comment, or view any reconciliation. This role is also referred to as the Reconciliations Global Admin. The default setting is the standard Administrators User Group.
NOTE: Anyone in the Administrators User Group is a OneStream System Administrator and, by default, can perform any of the same duties as a Reconciliations Global Admin.
Different from the OneStream System Administrator, this can be someone in the Administer Application Security Role User Group, which is configured under the Application tab and then in Security Roles. This User Group could be different from a System Administrator if the Administrators User Group is not assigned. If it is desired for anyone with this OneStream application’s Administer Application Security Role to also play the role of Reconciliations Global Admin, include that same User Group as a member of the User Group assigned to Security Role [Manage Reconciliation Setup].
View Only Group:: This group can see reconciliations but cannot make any changes or log any reconciliation line items. This group must also have Access Group privileges to the workflow profiles where reconciliations are managed.
Auditor Group: This group can see Fully Approved reconciliations only and can add comments to Fully Approved reconciliations.
Process Reconciliations: This dictates which role(s) can and cannot process reconciliations. The default is for Solution Admins and above. Any role that does not have the capability to run process will not see the Process icon on the Reconciliations Grid.
Local Admin
Update Inventory and Groups: When set to Enabled, the Local Admin will have access to the Inventory and Groups pages. This also provides the flexibility to update inventory and groups through and excel improt. When set to Disabled, they will not have access to the Inventory and Groups pages.
NOTE: When the Local Admin is limited to updating certain fields, they cannot update groups or inventory through the import, only through the UI.
Delete Inventory and Groups: When Enabled, the Local Admin can delete inventory and groups. When Disabled, the Local Admin cannot delete inventory or groups.
NOTE: When disabled, the Delete icon does not display.
Update Access Group: When Enabled, the Local Admin can edit users and roles within the Access Groups they are part of. When Disabled, they cannot update users and roles within the Access Groups. The setting default is Disabled.
NOTE: This setting enables updates within the Access Group. Whether the Local Admin can associate an Access Group with a reconciliation is controlled by the Inventory Editable Fields below.
Complete Workflow: When Enabled, the Local Admin can complete the workflow. When Disabled, the Local Admin cannot complete the workflow.
NOTE: When disabled, the Complete Workflow icon does not display.
To Complete Workflow, the Local Admin must be part of the platform group assigned to the Workflow Execution Group within the Workflow Profile.
If the Local Admin is not part of the platform group, even if they are enabled within the Global Options, they will receive an error.
Inventory Editable Fields: The Solution Admin can select which Inventory fields can be edited by the Local Admin. To set Inventory Editable Fields, the Solution Admin can move fields between two panes. The fields listed in the Inventory Editable Fields pane can be edited by the Local Admin and the fields listed in the Inventory Available Fields pane cannot.
For example, the Solution Admin gives the Local Admin access to update the Preparer and Approver 1 fields and the Local Admin can view the other fields as read-only.
NOTE: When the Solution Admin restricts editing of fields, the Local Admin cannot update through an import file, only through the UI.
Account Group Editable Fields: The Solution Admin can select which Account Group fields can be edited by the Local Admin. This functions the same as Inventory Editable Fields, but with the Account Group Fields.
NOTE: When any Account Groups fields are limited from being edited, the Local Admin cannot make updates through an import file or create or copy account groups.
Reconciliation Data Management
Source Scenario: Typically the Actual scenario. When Discover is performed during reconciliation, this is the scenario queried for balances.
Reconciliation Scenario: Set this up as a scenario separate from Actual, for example, a scenario called ActualAR. This is a mirror of Actual but assigned a different scenario type, so a different workflow profile can be used with it. Therefore, it can have separate workflow locking from the Actual scenario type scenarios.
Source Account Desc. Dimension: Select the field (Label, Text Value, or Attributes 1–20) to populate the S.Account Desc. column in grids and the description in the detailed reconciliation header and reports for individual reconciliations. Default value is (Unassigned).
NOTE: If you have more than one source account description associated with a single source account, the S.Account Desc. field is only populated with one. In this scenario, you cannot select a specific source account description, so if a specific value is required, ensure the source import data being mapped to the account is consistent.
IMPORTANT: After you update the Source Account Description Dimension, you must save the change and then run Discover.
Account Dimension: Select the Account dimension containing the accounts to be reconciled.
Auto Create Definitions: If (default) is selected, when a user selects Discover on the Reconciliation’s Definition, a Reconciliation Definition is added for any account in the Account List that does not yet have one.
Process Reconciliations on Complete Workflow: If selected, this initiates Process Reconciliations before marking the workflow as completed. If balances have changed, then the workflow cannot be completed.
NOTE: The Process Reconciliations action performed as part of the Complete workflow step is an in-line action. Running Process at the Base Input or Review level are data management jobs.
Default Rec ID to (Group):
-
If selected, when you create an I-Item for an account group, the Reconciliation ID field will be (Group) by default. You can change the reconciliation ID before you save it.
-
If clear (default), when you create an I-Item for an account group, the Reconciliation ID field will be blank by default. You must select an option from the drop-down menu for this required field.
IMPORTANT: After you select a reconciliation ID and save the item, it cannot be edited. To update the reconciliation ID, delete the item and then add it with the correct reconciliation ID.
Edit Template Items: When enabled, you can delete individual line items created from templates (S-Docs or T-Docs). If not enabled, you receive an error and must delete the entire S-Doc or T-Doc, then reupload the template to make the change.
Audit Files Use Target Name Only: Controls the naming convention for Audit Package files. If selected, audit files that are created will only use the target account and entity in the file name. If clear, the audit files are created with the Source and Target Account and Entity in the file name. This is deselected by default.
NOTE: The check box should be selected if there is a possibility that the file name length exceeds the Windows limit of 260-character file names. If the file name exceeds 260-characters, the Audit Package file will not be generated. Windows 10 does enable users to change the 260-character limit by changing the Windows Group Policy.
Require R-Doc: If selected, each reconciliation that is not auto reconciled must have an R-Doc attached to selectthe Prepare button.
Approver Attachments: If selected, this enables approvers to add attachments to prepared reconciliations.
Account Member Filter: Enter an account-based member filter used to query a list of accounts to reconcile.
Example: A#[Balance Sheet].Base, A#1000, A#2000.Base
If Extensible Dimensionality is being used on the Account dimension in this application, this member filter must be adjusted to query accounts differently across each cube. This is because an account could be a base member in one Account dimension and a parent in another.
Example: A#[Balance Sheet].Base.Options(Cube=[GolfStream], ScenarioType=Actual),A#[Balance Sheet].Base.Options(Cube=[Houston], ScenarioType=Actual)
Multi-Currency
Multi-Currency: Enables the multi-currency features in the solution.
NOTE: After you select this button and save the settings, multi-currency cannot be disabled. It is strongly recommended that this feature be tested in a development application because you cannot revert to single currency reconciliations.
The impact of multi-currency is discussed throughout the guide. Enabling multi-currency enables you to have a currency type set at the Source Account level (GL Account). The Account currency type for each reconciliation item is maintained within the Reconciliation Inventory. This differs from the Local currency (maintained on the Entity dimension) and Reporting currency (maintained at the cube level). Therefore, each reconciliation item may have a different account currency.
Reconciliations with a common target entity will have the same Local currency, and all reconciliations within an application will have a single Reporting currency. In addition, for reconciliations where multi-currency is enabled, Account, Local, and Reporting currencies all display in the Account Reconciliations user interface.
Detail items may also be created using any currency type maintained in OneStream and are automatically translated to Account, Local, and Reporting currencies upon save. Also, Account Groups may be created for accounts or entities that have different currency types, allowing child reconciliations to be translated and aggregated to a single reconciling currency type, for each currency level, at the Account Group level.
FX Rate Type
Single Currency Solutions: The FX Rate Type being used to calculate the reconciliation balances on specific reports. Examples include ClosingRate or AverageRate. If this is not populated, no translated values are available in reports. This must be set even if multi-currency is enabled because some reconciliations within the Reconciliation Inventory may remain single Currency.
Multi-currency Solutions: The FX Rate Type being used to translate reconciliation balances from Local currency to Account currency and from Local currency to Reporting currency. Translation from one currency level to another only occurs if the account or reporting balances are not loaded into Stage. Local currency is the base-level currency and is the level that is reconciled for single currency applications. Therefore, local balances are required for multi-currency reconciliations. This is also the rate type used to translate detail items from the detail currency type to the Account, Local, and Reporting currency types. If this is not populated, translations do not occur.
FX Reporting Currency
Single Currency Solutions: The currency type used as the target currency for reports that translate values. If this is not populated, no translated values will be available on these reports.
Note on translation in certain reports: Account Reconciliations provides a translated value in certain reports for the convenience and analysis of the administrator or end user. This translated value is not stored but is calculated based on settings in Global Options as the report is being processed. This is a simple translation being run that assumes a calculation similar to the Direct translation method of multiplying what is expected to be a Year to Date value by the FX Rate Type specified in Global Setup. However, these are not the same translation algorithms being processed, and no custom translation methods business rules) are supported. These reports note that they are translated by listing this FX Reporting Currency in the right side of the report’s header section.
NOTE: To see the reports within the Reports and Analysis in different currency types, enable multi-currency.
Notifications
Email Connection: The named email connection used for notifications. The connections listed in this drop-down menu derive from the initial server configuration.
New OneStream Account(s): New account is included in the Account List after running Discover.
New Reconciliation(s) Discovered: New Reconciliation Inventory items are found after running Discover.
Balance Changed: A reconciled balance was changed either after it was marked Complete or set to In Process and is different from the original value.
Integration
Transaction Matching Integration: Select to enable integration with the Transaction Matching solution.
IMPORTANT: After you enable integration with Transaction Matching and save the settings, you cannot disable the integration.
Mass Actions
Mass Prepare: Preparer can complete or recall multiple reconciliations.
Mass Approve: Approver can approve, unapprove, or reject multiple reconciliations.
Global Defaults
Default Reconciliation Definition: Default attributes for all new Reconciliation Definitions created during the Discover process. See Reconciliation Definition for details on configuration. This only occurs if the Auto Create Reconciliation Definition property of Global Options is selected.
Default Reconciliation Attributes: Default attributes for Security Roles (Preparer, Approvers 1–4, and Access Group) and Notification Method. Note that the same user cannot be assigned to more than one security role.
These settings apply to all new Reconciliation Inventory items created during the Discover process. See Reconciliation Inventory for details on configuration.
Default Reconciliation Time-based Attributes: Default attributes for time-based attributes. These settings apply to all new Reconciliation Inventory items created during the Discover process.
